Introduction

The CCN clearinghouse provides a synthesized and curated set of coastal carbon data that promotes the sharing of open data, novel analyses, and collaboration opportunities. The synthesis is created by curating and merging publicly available data through an automated script. This report documents the success or failure of the automated synthesis process, documents changes, conducts QA/QC tests, and provides visualizations and summaries of data within the clearinghouse.

Report date: 2024/03/05-11:56

Synthesis status: Successful

Contact: Jaxine Wolfe ()

Database Overview

Currently, this synthesis contains 502 studies with soil carbon associated observations across 3901 sites and 13475 cores from around the world. Observations represent a 62 year timespan, from 1960 to 2022.

QA/QC Test Results

Overview

Relational Tables

Cases where a core ID is present in the core-level table but not the depthseries.

Cases where a core ID is present in the depthseries table but not the core-level table.

Uncontrolled Attributes

The studies with uncontrolled attributes in essential tables are the following:

Belshe_et_al_2019, Breithaupt_et_al_2014, Callaway_et_al_2019, Darienzo_and_Peterson_1990, Everhart_et_al_2020, Morrissette_et_al_2023, Radabaugh_et_al_2021

This table provides a more detailed breakdown of these attributes and the values associated with them:

Uncontrolled Variables

COMING SOON

Numeric Attributes

Summary Statistics:

Bibliography

## [1] "The following studies do not have citation information present."
## [1] "Stahl_et_al_2024"             "Palinkas_and_Engelhardt_2024" "Palinkas_and_Cornwell_2024"  
## [4] "Marot_et_al_2020"             "Drake_et_al_2024"             "Craft_2024"

Check Post-Processing

Habitat Assignments

habitat n pct
marsh 6911 51.28
mangrove 4484 33.27
seagrass 940 6.97
unvegetated 644 4.78
swamp 216 1.60
scrub/shrub 111 0.82
unknown 100 0.74
algal mat 63 0.47
upland 8 0.06

The following table shows which cores are currently not assigned any habitat:

Geography Assignments

The following table shows which cores are currently not assigned any country. This may be because the latitude and longitude are undefined.

MORE COMING SOON

Depthseries Visualization

Depth Interval Checks

Instances of multiple observations for the same interval within a unique core (and unique method ID) were found in the following 32 studies:

Boyd_et_al_2017, Buffington_et_al_2020, Callaway_et_al_2019, CRMS_Database, Drexler_et_al_2009, Drexler_et_al_2013, Everhart_et_al_2020, Fourqurean_and_Kendrick_unpublished, Gerlach_et_al_2017, Gonneea_et_al_2004, Howard_and_Fourqurean_2020, Kemp_et_al_2020, Kumar_et_al_2020, Langston_et_al_2022, MacKenzie_et_al_2021, Marot_et_al_2020, Messerschmidt_and_Kirwan_2020, Nahlik_and_Fennessy_2016, NCSS, Oakes_and_Connolly_2004, Orson_1990, Paula_et_al_2001, Rigollet_et_al_2004, Schieder_and_Kirwan_2019, Smeaton_et_al_2022b, Smeaton_et_al_2023, Stahl_et_al_2024, StLaurent_et_al_2020, Trettin_et_al_2017, Van_de_Broek_et_al_2018, Wang_et_al_2023, Watson_and_Byrne_2013

There are 3207 single-interval surface samples (max depth < 20cm) and 168 single-interval subsurface samples. There are also 638 large single-interval samples (ex. one representative (?) sample for 0-100cm depth).

The following 2 studies had at least one depth interval where the depth max was less than the depth min: DelVecchia_et_al_2014, Thom_1992

Numeric Data Distributions

Relationship between organic matter (LOI) and carbon content

Change Log

COMING SOON

The following table summarizes which entries across the range of synthesis tables changed compared to the previous synthesis. Study IDs associated with the “forward” change type represent data that was not present in the previous synthesis, while “backward” indicates that study ID is no longer in the given table. If a study ID in a table is associated with both backward and forward change types, it is likely that one or more values were altered for that row in the new synthesis.

Miscellaneous

The following files were found in the derivative folders. They either do not match the approved filename structure for csvs or are another filetype

Unknown CSVs

##  [1] "data/primary_studies/CIFOR/derivative_SWAMP/cifor_swamp_allometric_eq.csv"                      
##  [2] "data/primary_studies/CIFOR/derivative_SWAMP/cifor_swamp_plant_plot_detail.csv"                  
##  [3] "data/primary_studies/CIFOR/derivative_SWAMP/cifor_swamp_plant.csv"                              
##  [4] "data/primary_studies/CIFOR/derivative_SWAMP/cifor_swamp_plot_summary.csv"                       
##  [5] "data/primary_studies/Dontis_et_al_2020/derivative/Dontis_et_al_2020_allometric_eq.csv"          
##  [6] "data/primary_studies/Dontis_et_al_2020/derivative/Dontis_et_al_2020_plant.csv"                  
##  [7] "data/primary_studies/Dontis_et_al_2020/derivative/Dontis_et_al_2020_plot_summary.csv"           
##  [8] "data/primary_studies/Fourqurean_2012/derivative/Fourqurean_2012_biomass.csv"                    
##  [9] "data/primary_studies/Gillen_et_al_2018/derivative/Gillen_et_al_2018_plant_plot_detail.csv"      
## [10] "data/primary_studies/Gillen_et_al_2018/derivative/Gillen_et_al_2018_plot_summary.csv"           
## [11] "data/primary_studies/Morgan_et_al_2024/derivative/morgan_et_al_2024_plot_summary.csv"           
## [12] "data/primary_studies/Morgan_et_al_2024/derivative/morgan_et_al_2024_site.csv"                   
## [13] "data/primary_studies/Radabaugh_et_al_2017/derivative/radabaugh_et_al_2017_allometric_eq.csv"    
## [14] "data/primary_studies/Radabaugh_et_al_2017/derivative/radabaugh_et_al_2017_plant_plot_detail.csv"
## [15] "data/primary_studies/Radabaugh_et_al_2017/derivative/radabaugh_et_al_2017_plant.csv"            
## [16] "data/primary_studies/Radabaugh_et_al_2017/derivative/radabaugh_et_al_2017_plot_summary.csv"     
## [17] "data/primary_studies/Radabaugh_et_al_2018/derivative/radabaugh_et_al_2018_plot_summary.csv"     
## [18] "data/primary_studies/Radabaugh_et_al_2023/derivative/radabaugh_et_al_2023_allometric_eq.csv"    
## [19] "data/primary_studies/Radabaugh_et_al_2023/derivative/radabaugh_et_al_2023_plant.csv"            
## [20] "data/primary_studies/Radabaugh_et_al_2023/derivative/radabaugh_et_al_2023_plot_summary.csv"     
## [21] "data/primary_studies/Simard_et_al_2019/derivative/Simard_et_al_2019_plant_plot_detail.csv"      
## [22] "data/primary_studies/Simard_et_al_2019/derivative/Simard_et_al_2019_plant.csv"                  
## [23] "data/primary_studies/Simard_et_al_2019/derivative/Simard_et_al_2019_plot_summary.csv"           
## [24] "data/primary_studies/Trettin_et_al_2020/derivative/trettin_et_al_2020_study_citation.csv"

Non .csv or .bib filetypes

##  [1] "data/primary_studies/Brown_et_al_2024/derivative/_readMe.txt"          
##  [2] "data/primary_studies/Darienzo_and_Peterson_1990/derivative/_readMe.rtf"
##  [3] "data/primary_studies/Dontis_et_al_2020/derivative/_readMe.txt"         
##  [4] "data/primary_studies/Everhart_et_al_2020/derivative/_readMe.txt"       
##  [5] "data/primary_studies/Gillen_et_al_2018/derivative/_readMe.txt"         
##  [6] "data/primary_studies/Langston_et_al_2022/derivative/_readMe.txt"       
##  [7] "data/primary_studies/Messerschmidt_et_al_2020/derivative/_readMe.txt"  
##  [8] "data/primary_studies/Morgan_et_al_2024/derivative/_readMe.rtf"         
##  [9] "data/primary_studies/Radabaugh_et_al_2017/derivative/_readMe.txt"      
## [10] "data/primary_studies/Radabaugh_et_al_2018/derivative/_readMe.txt"      
## [11] "data/primary_studies/Radabaugh_et_al_2021/derivative/_readMe.txt"      
## [12] "data/primary_studies/Radabaugh_et_al_2023/derivative/_readMe.txt"      
## [13] "data/primary_studies/Simard_et_al_2019/derivative/_readMe.rtf"         
## [14] "data/primary_studies/Smith_and_Kirwan_2021/derivative/_readMe.txt"     
## [15] "data/primary_studies/Stevens_et_al_2024/derivative/_readMe.txt"        
## [16] "data/primary_studies/Vinent_and_Kirwan_2017/derivative/_readMe.txt"

Warnings Encountered

## Summary of (a total of 2) warning messages:
## 1x : There was 1 warning in `mutate()`.
## ℹ In argument: `across(everything(), as.numeric)`.
## Caused by warning:
## ! NAs introduced by coercion
## 1x : There was 1 warning in `dplyr::summarize()`.
## ℹ In argument: `dplyr::across(tidyselect::any_of(variable_names), mangled_skimmers$funs)`.
## ℹ In group 0: .
## Caused by warning:
## ! There were 2 warnings in `dplyr::summarize()`.
## The first warning was:
## ℹ In argument: `dplyr::across(tidyselect::any_of(variable_names), mangled_skimmers$funs)`.
## Caused by warning in `min()`:
## ! no non-missing arguments to min; returning Inf
## ℹ Run ]8;;ide:run:dplyr::last_dplyr_warnings()dplyr::last_dplyr_warnings()]8;; to see the 1 remaining warning.